package com.ctsi.ntedu.domain;

import com.ctsi.ssdc.criteria.IntegerCriteria;
import com.ctsi.ssdc.criteria.StringCriteria;
import com.ctsi.ssdc.criteria.ZonedDateTimeCriteria;
import com.ctsi.ssdc.example.BaseExample;
import io.swagger.annotations.ApiParam;
import java.time.ZonedDateTime;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.lang3.StringUtils;

/**
 * @author ctsi-biyi-generator
*/
public class NteduRecordExample extends BaseExample {
    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    protected String orderByClause;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    protected boolean distinct;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    protected List<Criteria> oredCriteria;

    /**
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private static final String LIKE_FORMAT = "%%%s%%";

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.id
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria id;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.school_id
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria schoolId;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.acc_nbr
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private StringCriteria accNbr;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.call_in
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria callIn;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.call_out
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria callOut;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.complete
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria complete;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.lose
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria lose;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.leave_word
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria leaveWord;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.dt
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private ZonedDateTimeCriteria dt;

    /**
     *
     * This field was generated by MyBatis Generator.
     * This field corresponds to the database column ntedu_record.hour
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private IntegerCriteria hour;

    private transient StringCriteria date;


    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public NteduRecordExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getId() {
        return id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setId(IntegerCriteria id) {
        this. id = id;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildIdCriteria(Criteria criteria) {
        if (this.getId() == null) {
            return;
        }
        if (this.getId().getEquals() != null) {
            criteria.andIdEqualTo(this.getId().getEquals());
        } else {
            if (this.getId().getGreaterOrEqualThan() != null) {
                criteria.andIdGreaterThanOrEqualTo(this.getId().getGreaterOrEqualThan());
            }
            if (this.getId().getLessOrEqualThan() != null) {
                criteria.andIdLessThanOrEqualTo(this.getId().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getSchoolId() {
        return schoolId;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setSchoolId(IntegerCriteria schoolId) {
        this. schoolId = schoolId;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildSchoolIdCriteria(Criteria criteria) {
        if (this.getSchoolId() == null) {
            return;
        }
        if (this.getSchoolId().getEquals() != null) {
            criteria.andSchoolIdEqualTo(this.getSchoolId().getEquals());
        } else {
            if (this.getSchoolId().getGreaterOrEqualThan() != null) {
                criteria.andSchoolIdGreaterThanOrEqualTo(this.getSchoolId().getGreaterOrEqualThan());
            }
            if (this.getSchoolId().getLessOrEqualThan() != null) {
                criteria.andSchoolIdLessThanOrEqualTo(this.getSchoolId().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public StringCriteria getAccNbr() {
        return accNbr;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setAccNbr(StringCriteria accNbr) {
        this. accNbr = accNbr;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildAccNbrCriteria(Criteria criteria) {
        if (this.getAccNbr() == null) {
            return;
        }
        if (this.getAccNbr().getEquals() != null) {
            criteria.andAccNbrEqualTo(this.getAccNbr().getEquals());
        } else {
            if (StringUtils.isNotBlank(this.getAccNbr().getContains())) {
                criteria.andAccNbrLike(String.format(LIKE_FORMAT, this.getAccNbr().getContains()));
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getCallIn() {
        return callIn;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setCallIn(IntegerCriteria callIn) {
        this. callIn = callIn;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildCallInCriteria(Criteria criteria) {
        if (this.getCallIn() == null) {
            return;
        }
        if (this.getCallIn().getEquals() != null) {
            criteria.andCallInEqualTo(this.getCallIn().getEquals());
        } else {
            if (this.getCallIn().getGreaterOrEqualThan() != null) {
                criteria.andCallInGreaterThanOrEqualTo(this.getCallIn().getGreaterOrEqualThan());
            }
            if (this.getCallIn().getLessOrEqualThan() != null) {
                criteria.andCallInLessThanOrEqualTo(this.getCallIn().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getCallOut() {
        return callOut;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setCallOut(IntegerCriteria callOut) {
        this. callOut = callOut;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildCallOutCriteria(Criteria criteria) {
        if (this.getCallOut() == null) {
            return;
        }
        if (this.getCallOut().getEquals() != null) {
            criteria.andCallOutEqualTo(this.getCallOut().getEquals());
        } else {
            if (this.getCallOut().getGreaterOrEqualThan() != null) {
                criteria.andCallOutGreaterThanOrEqualTo(this.getCallOut().getGreaterOrEqualThan());
            }
            if (this.getCallOut().getLessOrEqualThan() != null) {
                criteria.andCallOutLessThanOrEqualTo(this.getCallOut().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getComplete() {
        return complete;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setComplete(IntegerCriteria complete) {
        this. complete = complete;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildCompleteCriteria(Criteria criteria) {
        if (this.getComplete() == null) {
            return;
        }
        if (this.getComplete().getEquals() != null) {
            criteria.andCompleteEqualTo(this.getComplete().getEquals());
        } else {
            if (this.getComplete().getGreaterOrEqualThan() != null) {
                criteria.andCompleteGreaterThanOrEqualTo(this.getComplete().getGreaterOrEqualThan());
            }
            if (this.getComplete().getLessOrEqualThan() != null) {
                criteria.andCompleteLessThanOrEqualTo(this.getComplete().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getLose() {
        return lose;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setLose(IntegerCriteria lose) {
        this. lose = lose;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildLoseCriteria(Criteria criteria) {
        if (this.getLose() == null) {
            return;
        }
        if (this.getLose().getEquals() != null) {
            criteria.andLoseEqualTo(this.getLose().getEquals());
        } else {
            if (this.getLose().getGreaterOrEqualThan() != null) {
                criteria.andLoseGreaterThanOrEqualTo(this.getLose().getGreaterOrEqualThan());
            }
            if (this.getLose().getLessOrEqualThan() != null) {
                criteria.andLoseLessThanOrEqualTo(this.getLose().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getLeaveWord() {
        return leaveWord;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setLeaveWord(IntegerCriteria leaveWord) {
        this. leaveWord = leaveWord;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildLeaveWordCriteria(Criteria criteria) {
        if (this.getLeaveWord() == null) {
            return;
        }
        if (this.getLeaveWord().getEquals() != null) {
            criteria.andLeaveWordEqualTo(this.getLeaveWord().getEquals());
        } else {
            if (this.getLeaveWord().getGreaterOrEqualThan() != null) {
                criteria.andLeaveWordGreaterThanOrEqualTo(this.getLeaveWord().getGreaterOrEqualThan());
            }
            if (this.getLeaveWord().getLessOrEqualThan() != null) {
                criteria.andLeaveWordLessThanOrEqualTo(this.getLeaveWord().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public ZonedDateTimeCriteria getDt() {
        return dt;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setDt(ZonedDateTimeCriteria dt) {
        this. dt = dt;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildDtCriteria(Criteria criteria) {
        if (this.getDt() == null) {
            return;
        }
        if (this.getDt().getEquals() != null) {
            criteria.andDtEqualTo(this.getDt().getEquals());
        } else {
            if (this.getDt().getGreaterOrEqualThan() != null) {
                criteria.andDtGreaterThanOrEqualTo(this.getDt().getGreaterOrEqualThan());
            }
            if (this.getDt().getLessOrEqualThan() != null) {
                criteria.andDtLessThanOrEqualTo(this.getDt().getLessOrEqualThan());
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public IntegerCriteria getHour() {
        return hour;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public void setHour(IntegerCriteria hour) {
        this. hour = hour;
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    private void buildHourCriteria(Criteria criteria) {
        if (this.getHour() == null) {
            return;
        }
        if (this.getHour().getEquals() != null) {
            criteria.andHourEqualTo(this.getHour().getEquals());
        } else {
            if (this.getHour().getGreaterOrEqualThan() != null) {
                criteria.andHourGreaterThanOrEqualTo(this.getHour().getGreaterOrEqualThan());
            }
            if (this.getHour().getLessOrEqualThan() != null) {
                criteria.andHourLessThanOrEqualTo(this.getHour().getLessOrEqualThan());
            }
        }
    }

    public StringCriteria getDate() {
        return date;
    }

    public void setDate(StringCriteria date) {
        this.date = date;
    }

    private void buildDateCriteria(Criteria criteria) {
        if (this.getDate() == null) {
            return;
        }
        if (this.getDate().getEquals() != null) {
            criteria.andAccNbrEqualTo(this.getDate().getEquals());
        } else {
            if (StringUtils.isNotBlank(this.getDate().getContains())) {
                criteria.andAccNbrLike(String.format(LIKE_FORMAT, this.getDate().getContains()));
            }
        }
    }

    /**
     * This method was generated by MyBatis Generator.
     * This method corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public Object buildCriteria() {
        Criteria criteria = this.createCriteria();
        this.buildIdCriteria(criteria);
        this.buildSchoolIdCriteria(criteria);
        this.buildAccNbrCriteria(criteria);
        this.buildCallInCriteria(criteria);
        this.buildCallOutCriteria(criteria);
        this.buildCompleteCriteria(criteria);
        this.buildLoseCriteria(criteria);
        this.buildLeaveWordCriteria(criteria);
        this.buildDtCriteria(criteria);
        this.buildHourCriteria(criteria);
        this.buildDateCriteria(criteria);
        return criteria;
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIsNull() {
            addCriterion("school_id is null");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIsNotNull() {
            addCriterion("school_id is not null");
            return (Criteria) this;
        }

        public Criteria andSchoolIdEqualTo(Integer value) {
            addCriterion("school_id =", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotEqualTo(Integer value) {
            addCriterion("school_id <>", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdGreaterThan(Integer value) {
            addCriterion("school_id >", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("school_id >=", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdLessThan(Integer value) {
            addCriterion("school_id <", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdLessThanOrEqualTo(Integer value) {
            addCriterion("school_id <=", value, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdIn(List<Integer> values) {
            addCriterion("school_id in", values, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotIn(List<Integer> values) {
            addCriterion("school_id not in", values, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdBetween(Integer value1, Integer value2) {
            addCriterion("school_id between", value1, value2, "schoolId");
            return (Criteria) this;
        }

        public Criteria andSchoolIdNotBetween(Integer value1, Integer value2) {
            addCriterion("school_id not between", value1, value2, "schoolId");
            return (Criteria) this;
        }

        public Criteria andAccNbrIsNull() {
            addCriterion("acc_nbr is null");
            return (Criteria) this;
        }

        public Criteria andAccNbrIsNotNull() {
            addCriterion("acc_nbr is not null");
            return (Criteria) this;
        }

        public Criteria andAccNbrEqualTo(String value) {
            addCriterion("acc_nbr =", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrNotEqualTo(String value) {
            addCriterion("acc_nbr <>", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrGreaterThan(String value) {
            addCriterion("acc_nbr >", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrGreaterThanOrEqualTo(String value) {
            addCriterion("acc_nbr >=", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrLessThan(String value) {
            addCriterion("acc_nbr <", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrLessThanOrEqualTo(String value) {
            addCriterion("acc_nbr <=", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrLike(String value) {
            addCriterion("acc_nbr like", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrNotLike(String value) {
            addCriterion("acc_nbr not like", value, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrIn(List<String> values) {
            addCriterion("acc_nbr in", values, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrNotIn(List<String> values) {
            addCriterion("acc_nbr not in", values, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrBetween(String value1, String value2) {
            addCriterion("acc_nbr between", value1, value2, "accNbr");
            return (Criteria) this;
        }

        public Criteria andAccNbrNotBetween(String value1, String value2) {
            addCriterion("acc_nbr not between", value1, value2, "accNbr");
            return (Criteria) this;
        }

        public Criteria andCallInIsNull() {
            addCriterion("call_in is null");
            return (Criteria) this;
        }

        public Criteria andCallInIsNotNull() {
            addCriterion("call_in is not null");
            return (Criteria) this;
        }

        public Criteria andCallInEqualTo(Integer value) {
            addCriterion("call_in =", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInNotEqualTo(Integer value) {
            addCriterion("call_in <>", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInGreaterThan(Integer value) {
            addCriterion("call_in >", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInGreaterThanOrEqualTo(Integer value) {
            addCriterion("call_in >=", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInLessThan(Integer value) {
            addCriterion("call_in <", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInLessThanOrEqualTo(Integer value) {
            addCriterion("call_in <=", value, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInIn(List<Integer> values) {
            addCriterion("call_in in", values, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInNotIn(List<Integer> values) {
            addCriterion("call_in not in", values, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInBetween(Integer value1, Integer value2) {
            addCriterion("call_in between", value1, value2, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallInNotBetween(Integer value1, Integer value2) {
            addCriterion("call_in not between", value1, value2, "callIn");
            return (Criteria) this;
        }

        public Criteria andCallOutIsNull() {
            addCriterion("call_out is null");
            return (Criteria) this;
        }

        public Criteria andCallOutIsNotNull() {
            addCriterion("call_out is not null");
            return (Criteria) this;
        }

        public Criteria andCallOutEqualTo(Integer value) {
            addCriterion("call_out =", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutNotEqualTo(Integer value) {
            addCriterion("call_out <>", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutGreaterThan(Integer value) {
            addCriterion("call_out >", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutGreaterThanOrEqualTo(Integer value) {
            addCriterion("call_out >=", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutLessThan(Integer value) {
            addCriterion("call_out <", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutLessThanOrEqualTo(Integer value) {
            addCriterion("call_out <=", value, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutIn(List<Integer> values) {
            addCriterion("call_out in", values, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutNotIn(List<Integer> values) {
            addCriterion("call_out not in", values, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutBetween(Integer value1, Integer value2) {
            addCriterion("call_out between", value1, value2, "callOut");
            return (Criteria) this;
        }

        public Criteria andCallOutNotBetween(Integer value1, Integer value2) {
            addCriterion("call_out not between", value1, value2, "callOut");
            return (Criteria) this;
        }

        public Criteria andCompleteIsNull() {
            addCriterion("complete is null");
            return (Criteria) this;
        }

        public Criteria andCompleteIsNotNull() {
            addCriterion("complete is not null");
            return (Criteria) this;
        }

        public Criteria andCompleteEqualTo(Integer value) {
            addCriterion("complete =", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteNotEqualTo(Integer value) {
            addCriterion("complete <>", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteGreaterThan(Integer value) {
            addCriterion("complete >", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteGreaterThanOrEqualTo(Integer value) {
            addCriterion("complete >=", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteLessThan(Integer value) {
            addCriterion("complete <", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteLessThanOrEqualTo(Integer value) {
            addCriterion("complete <=", value, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteIn(List<Integer> values) {
            addCriterion("complete in", values, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteNotIn(List<Integer> values) {
            addCriterion("complete not in", values, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteBetween(Integer value1, Integer value2) {
            addCriterion("complete between", value1, value2, "complete");
            return (Criteria) this;
        }

        public Criteria andCompleteNotBetween(Integer value1, Integer value2) {
            addCriterion("complete not between", value1, value2, "complete");
            return (Criteria) this;
        }

        public Criteria andLoseIsNull() {
            addCriterion("lose is null");
            return (Criteria) this;
        }

        public Criteria andLoseIsNotNull() {
            addCriterion("lose is not null");
            return (Criteria) this;
        }

        public Criteria andLoseEqualTo(Integer value) {
            addCriterion("lose =", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseNotEqualTo(Integer value) {
            addCriterion("lose <>", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseGreaterThan(Integer value) {
            addCriterion("lose >", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseGreaterThanOrEqualTo(Integer value) {
            addCriterion("lose >=", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseLessThan(Integer value) {
            addCriterion("lose <", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseLessThanOrEqualTo(Integer value) {
            addCriterion("lose <=", value, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseIn(List<Integer> values) {
            addCriterion("lose in", values, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseNotIn(List<Integer> values) {
            addCriterion("lose not in", values, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseBetween(Integer value1, Integer value2) {
            addCriterion("lose between", value1, value2, "lose");
            return (Criteria) this;
        }

        public Criteria andLoseNotBetween(Integer value1, Integer value2) {
            addCriterion("lose not between", value1, value2, "lose");
            return (Criteria) this;
        }

        public Criteria andLeaveWordIsNull() {
            addCriterion("leave_word is null");
            return (Criteria) this;
        }

        public Criteria andLeaveWordIsNotNull() {
            addCriterion("leave_word is not null");
            return (Criteria) this;
        }

        public Criteria andLeaveWordEqualTo(Integer value) {
            addCriterion("leave_word =", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordNotEqualTo(Integer value) {
            addCriterion("leave_word <>", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordGreaterThan(Integer value) {
            addCriterion("leave_word >", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordGreaterThanOrEqualTo(Integer value) {
            addCriterion("leave_word >=", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordLessThan(Integer value) {
            addCriterion("leave_word <", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordLessThanOrEqualTo(Integer value) {
            addCriterion("leave_word <=", value, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordIn(List<Integer> values) {
            addCriterion("leave_word in", values, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordNotIn(List<Integer> values) {
            addCriterion("leave_word not in", values, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordBetween(Integer value1, Integer value2) {
            addCriterion("leave_word between", value1, value2, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andLeaveWordNotBetween(Integer value1, Integer value2) {
            addCriterion("leave_word not between", value1, value2, "leaveWord");
            return (Criteria) this;
        }

        public Criteria andDtIsNull() {
            addCriterion("dt is null");
            return (Criteria) this;
        }

        public Criteria andDtIsNotNull() {
            addCriterion("dt is not null");
            return (Criteria) this;
        }

        public Criteria andDtEqualTo(ZonedDateTime value) {
            addCriterion("dt =", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotEqualTo(ZonedDateTime value) {
            addCriterion("dt <>", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtGreaterThan(ZonedDateTime value) {
            addCriterion("dt >", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtGreaterThanOrEqualTo(ZonedDateTime value) {
            addCriterion("dt >=", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtLessThan(ZonedDateTime value) {
            addCriterion("dt <", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtLessThanOrEqualTo(ZonedDateTime value) {
            addCriterion("dt <=", value, "dt");
            return (Criteria) this;
        }

        public Criteria andDtIn(List<ZonedDateTime> values) {
            addCriterion("dt in", values, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotIn(List<ZonedDateTime> values) {
            addCriterion("dt not in", values, "dt");
            return (Criteria) this;
        }

        public Criteria andDtBetween(ZonedDateTime value1, ZonedDateTime value2) {
            addCriterion("dt between", value1, value2, "dt");
            return (Criteria) this;
        }

        public Criteria andDtNotBetween(ZonedDateTime value1, ZonedDateTime value2) {
            addCriterion("dt not between", value1, value2, "dt");
            return (Criteria) this;
        }

        public Criteria andHourIsNull() {
            addCriterion("hour is null");
            return (Criteria) this;
        }

        public Criteria andHourIsNotNull() {
            addCriterion("hour is not null");
            return (Criteria) this;
        }

        public Criteria andHourEqualTo(Integer value) {
            addCriterion("hour =", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourNotEqualTo(Integer value) {
            addCriterion("hour <>", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourGreaterThan(Integer value) {
            addCriterion("hour >", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourGreaterThanOrEqualTo(Integer value) {
            addCriterion("hour >=", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourLessThan(Integer value) {
            addCriterion("hour <", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourLessThanOrEqualTo(Integer value) {
            addCriterion("hour <=", value, "hour");
            return (Criteria) this;
        }

        public Criteria andHourIn(List<Integer> values) {
            addCriterion("hour in", values, "hour");
            return (Criteria) this;
        }

        public Criteria andHourNotIn(List<Integer> values) {
            addCriterion("hour not in", values, "hour");
            return (Criteria) this;
        }

        public Criteria andHourBetween(Integer value1, Integer value2) {
            addCriterion("hour between", value1, value2, "hour");
            return (Criteria) this;
        }

        public Criteria andHourNotBetween(Integer value1, Integer value2) {
            addCriterion("hour not between", value1, value2, "hour");
            return (Criteria) this;
        }

        public Criteria andDateIsNull() {
            addCriterion("date is null");
            return (Criteria) this;
        }

        public Criteria andDateIsNotNull() {
            addCriterion("date is not null");
            return (Criteria) this;
        }

        public Criteria andDateEqualTo(String value) {
            addCriterion("date =", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotEqualTo(String value) {
            addCriterion("date <>", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateGreaterThan(String value) {
            addCriterion("date >", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateGreaterThanOrEqualTo(String value) {
            addCriterion("date >=", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateLessThan(String value) {
            addCriterion("date <", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateLessThanOrEqualTo(String value) {
            addCriterion("date <=", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateLike(String value) {
            addCriterion("date like", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotLike(String value) {
            addCriterion("date not like", value, "date");
            return (Criteria) this;
        }

        public Criteria andDateIn(List<String> values) {
            addCriterion("date in", values, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotIn(List<String> values) {
            addCriterion("date not in", values, "date");
            return (Criteria) this;
        }

        public Criteria andDateBetween(String value1, String value2) {
            addCriterion("date between", value1, value2, "date");
            return (Criteria) this;
        }

        public Criteria andDateNotBetween(String value1, String value2) {
            addCriterion("date not between", value1, value2, "date");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ntedu_record
     *
     * @mbg.generated do_not_delete_during_merge Fri Aug 06 15:41:13 CST 2021
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ntedu_record
     *
     * @mbg.generated Fri Aug 06 15:41:13 CST 2021
     */
    public static class Criterion {
        @ApiParam(hidden=true)
        private String condition;

        @ApiParam(hidden=true)
        private Object value;

        @ApiParam(hidden=true)
        private Object secondValue;

        @ApiParam(hidden=true)
        private boolean noValue;

        @ApiParam(hidden=true)
        private boolean singleValue;

        @ApiParam(hidden=true)
        private boolean betweenValue;

        @ApiParam(hidden=true)
        private boolean listValue;

        @ApiParam(hidden=true)
        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}